﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace QuanLyThuNgan
{
    public class BaFeeDAO
    {
        public string m_Insert_(string sobn, string loaidvu, string dvucode, string DonViTinh, float slg, decimal ThanhTien, float fee, decimal dongia, string dvt, int stt, decimal giabhyt)
        {
            string _sql = string.Format("exec dbo.usp_ThuNgan_BaFee_Insert '{0}','{1}','{2}',N'{3}',{4},{5},{6},{7},'{8}',{9},{10}",sobn,loaidvu,dvucode,DonViTinh,slg,ThanhTien,fee,dongia,dvt,stt,giabhyt);
            return _sql;
        }
        public string m_Delete_( string sobn,string dvucode)
        {
            string _sql = string.Format("exec dbo.usp_ThuNgan_BaFee_Delete '{0}','{1}'",sobn,dvucode);
            return _sql;
        }
        public string m_Update_(string sobn, string loaidvu, string dvucode, string DonViTinh, float slg, decimal ThanhTien, float fee, decimal dongia, string dvt, int stt,decimal giabhyt)
        {
            string _sql = string.Format("exec dbo.usp_ThuNgan_BaFee_Update '{0}','{1}','{2}',N'{3}',{4},{5},{6},{7},'{8}',{9},{10}", sobn, loaidvu, dvucode, DonViTinh, slg, ThanhTien, fee, dongia, dvt, stt, giabhyt);
            return _sql;
        }
    }
}
